SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 57814: Hadoop tables cannot be displayed with the SAS® Studio table viewer

DetailsAboutRate It

The SAS Studio table viewer cannot open tables from a library that uses the Hadoop LIBNAME engine. One of the following error messages might be generated:

ERROR: Libref libref is not assigned 

Error trying to establish connection.

A temporary circumvention is to set the SAS_HADOOP_ENABLE_INTERRUPT environment variable to NO before issuing the LIBNAME statement.

You can set the environment variable in a Sasv9_usermods.cfg configuration file that is specific to the application server being used by SAS Studio. Add a command like the following:

-set SAS_HADOOP_ENABLE_INTERRUPT "no"

You can also set the variable in your program in an OPTIONS statement before the LIBNAME statement. For example:

options set=SAS_HADOOP_ENABLE_INTERRUPT=NO;

This is a temporary circumvention that should be removed when this issue is resolved.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS StudioWindows 7 Ultimate x643.43.49.4 TS1M39.4 TS1M4
Windows 7 Ultimate 32 bit3.43.49.4 TS1M39.4 TS1M4
Windows 7 Professional x643.43.49.4 TS1M39.4 TS1M4
Windows 7 Professional 32 bit3.43.49.4 TS1M39.4 TS1M4
Windows 7 Home Premium x643.43.49.4 TS1M39.4 TS1M4
Windows 7 Home Premium 32 bit3.43.49.4 TS1M39.4 TS1M4
Windows 7 Enterprise x643.43.49.4 TS1M39.4 TS1M4
Windows 7 Enterprise 32 bit3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 Std3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 R2 Std3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 R2 Datacenter3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2012 Datacenter3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2008 for x643.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 2008 R23.43.49.4 TS1M39.4 TS1M4
Microsoft Windows Server 20083.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 103.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Pro x643.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Pro 32-bit3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Enterprise x643.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8.1 Enterprise 32-bit3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Pro x643.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Pro 32-bit3.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Enterprise x643.43.49.4 TS1M39.4 TS1M4
Microsoft Windows 8 Enterprise 32-bit3.43.49.4 TS1M39.4 TS1M4
Microsoft® Windows® for x643.43.49.4 TS1M39.4 TS1M4
64-bit Enabled AIX3.43.49.4 TS1M39.4 TS1M4
64-bit Enabled Solaris3.43.49.4 TS1M39.4 TS1M4
HP-UX IPF3.43.49.4 TS1M39.4 TS1M4
Linux for x643.43.49.4 TS1M39.4 TS1M4
Solaris for x643.43.49.4 TS1M39.4 TS1M4
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.